﻿DROP TABLE IF EXISTS `open_integral_exchange`;
CREATE TABLE `open_integral_exchange` (
  `integral_exchange_id` int(11) NOT NULL AUTO_INCREMENT,
  `goods_id` mediumint(8) unsigned NOT NULL,
  `integral` int(10) DEFAULT NULL,
  `exchange_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `exchange_type` varchar(5) DEFAULT NULL,
  `start_time` int(10) unsigned NOT NULL,
  `end_time` int(10) unsigned NOT NULL,
  `user_rank` varchar(255) NOT NULL,
  PRIMARY KEY (`integral_exchange_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;